
create proc [dbo].[SP_SEL_PRODUCTS_GetPRO_NAME_By_Pro_ACC_INVENTORTY]
@PROTYP_ID int,
@ACC_ID int
as
select a.PRO_ID,a.PRO_NAME,a.PRO_DESCRIPTION ,a.PRO_PRICE,A.PRO_QUANTITY
from dbo.PRODUCTS a  where a.PROTYP_ID=@PROTYP_ID
and    a.ACC_ID=@ACC_ID

